<html><head>
<meta charset="utf-8" />
</head>
<body>
<?php
include "db.php";
$sql="SELECT * FROM st_club WHERE statuss='a'";
$result = mysql_query($sql) or die( mysql_error());
$cuantos = mysql_num_rows($result);
echo"<table align='center' border='1'><tr><td>Resultados: $cuantos</td></tr></table><br>";
if ($cuantos !=0 or $search='') {
	while ($fila = mysql_fetch_assoc($result)) {
	echo "<table border='1' width='700' height='100' align='center'>
	<tr><td><b>".$fila['club_name']."</b>-Club #: ".$fila['club_number'].",Dist #: ".$fila['district']." Area: ".$fila['division'].$fila['areas'].", Est: ".$fila['charter_date']."</td></tr>
	<tr><td>".$fila['address1']."</td></tr>
	<tr><td>".$fila['address2'].", ".$fila['club_name'].", ".$fila['estado_id'].", ".$fila['cp'].",".$fila['country']."</td></tr>
	<tr><td>".$fila['phone']."</td></tr>
	<tr><td>Meeting Time: ".$fila['meeting_time'].", ".$fila['meeting_day']."</td></tr>
	<tr><td>Club Status:  ".$fila['club_status']."</td></tr>";
	echo " </table><br><br>";
	}
}
else { 
echo"No se econtrarón resultados de la busqueda.";
}
?>
</body></html>